﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace 大连顺秋服装厂产线
{
    class TestService
    {
        public static void DoCont()
        {
            List<Customer> customers = new List<Customer>();
            customers.Add(new Customer("6713", "6454"));
            customers.Add(new Customer("6714", "6455"));
            customers.Add(new Customer("6715", "6456"));
            customers.Add(new Customer("6716", "6457"));
            customers.Add(new Customer("6717", "6458"));
            customers.Add(new Customer("6718", "6459"));
            customers.Add(new Customer("6719", "6460"));
            customers.Add(new Customer("6720", "6461"));
            customers.Add(new Customer("6721", "6462"));
            customers.Add(new Customer("6722", "6463"));
            customers.Add(new Customer("6723", "6464"));
            customers.Add(new Customer("6724", "6465"));
            customers.Add(new Customer("6725", "6466"));
            customers.Add(new Customer("6726", "6467"));
            customers.Add(new Customer("6727", "6468"));
            customers.Add(new Customer("6728", "6469"));
            customers.Add(new Customer("6729", "6470"));
            customers.Add(new Customer("6730", "6471"));
            customers.Add(new Customer("6731", "6472"));
            customers.Add(new Customer("6732", "6473"));
            customers.Add(new Customer("6733", "6474"));
            customers.Add(new Customer("6734", "6475"));
            customers.Add(new Customer("6735", "6476"));
            customers.Add(new Customer("6736", "6477"));
            customers.Add(new Customer("6737", "6478"));
            customers.Add(new Customer("6738", "6479"));
            customers.Add(new Customer("6739", "6480"));
            customers.Add(new Customer("6740", "6481"));
            customers.Add(new Customer("6741", "6482"));
            customers.Add(new Customer("6742", "6483"));
            customers.Add(new Customer("6743", "6484"));
            customers.Add(new Customer("6744", "6485"));
            customers.Add(new Customer("6745", "6486"));
            customers.Add(new Customer("6746", "6487"));
            customers.Add(new Customer("6747", "6488"));
            customers.Add(new Customer("6748", "6489"));
            customers.Add(new Customer("6749", "6490"));
            customers.Add(new Customer("6750", "6491"));
            customers.Add(new Customer("6751", "6492"));
            customers.Add(new Customer("6752", "6493"));
            customers.Add(new Customer("6753", "6494"));
            customers.Add(new Customer("6754", "6495"));
            customers.Add(new Customer("6755", "6496"));
            customers.Add(new Customer("6756", "6497"));
            customers.Add(new Customer("6757", "6498"));
            customers.Add(new Customer("6758", "6499"));
            customers.Add(new Customer("6759", "6500"));
            customers.Add(new Customer("6760", "6501"));
            customers.Add(new Customer("6761", "6502"));
            customers.Add(new Customer("6762", "6503"));
            customers.Add(new Customer("6763", "6504"));
            customers.Add(new Customer("6764", "6505"));
            customers.Add(new Customer("6765", "6506"));
            customers.Add(new Customer("6766", "6507"));
            customers.Add(new Customer("6767", "6508"));
            customers.Add(new Customer("6768", "6509"));
            customers.Add(new Customer("6769", "6510"));
            customers.Add(new Customer("6770", "6511"));
            customers.Add(new Customer("6771", "6512"));
            customers.Add(new Customer("6772", "6513"));
            customers.Add(new Customer("6773", "6514"));
            customers.Add(new Customer("6774", "6515"));
            customers.Add(new Customer("6775", "6516"));
            customers.Add(new Customer("6776", "6517"));
            customers.Add(new Customer("6777", "6518"));
            customers.Add(new Customer("6778", "6519"));
            customers.Add(new Customer("6779", "6520"));
            customers.Add(new Customer("6780", "6521"));
            customers.Add(new Customer("6781", "6522"));
            customers.Add(new Customer("6782", "6523"));
            customers.Add(new Customer("6783", "6524"));
            customers.Add(new Customer("6784", "6525"));
            customers.Add(new Customer("6785", "6526"));
            customers.Add(new Customer("6786", "6527"));
            customers.Add(new Customer("6787", "6528"));
            customers.Add(new Customer("6788", "6529"));
            customers.Add(new Customer("6789", "6530"));
            customers.Add(new Customer("6790", "6531"));
            customers.Add(new Customer("6791", "6532"));
            customers.Add(new Customer("6792", "6533"));
            customers.Add(new Customer("6793", "6534"));
            customers.Add(new Customer("6794", "6535"));
            customers.Add(new Customer("6795", "6536"));
            customers.Add(new Customer("6796", "6537"));
            customers.Add(new Customer("6797", "6538"));
            customers.Add(new Customer("6798", "6539"));
            customers.Add(new Customer("6799", "6540"));
            customers.Add(new Customer("6800", "6541"));
            customers.Add(new Customer("6801", "6542"));
            customers.Add(new Customer("6802", "6543"));
            customers.Add(new Customer("6803", "6544"));
            customers.Add(new Customer("6804", "6545"));
            customers.Add(new Customer("6805", "6546"));
            customers.Add(new Customer("6806", "6547"));
            customers.Add(new Customer("6807", "6548"));
            customers.Add(new Customer("6808", "6549"));
            customers.Add(new Customer("6809", "6550"));
            customers.Add(new Customer("6810", "6551"));
            customers.Add(new Customer("6811", "6552"));
            customers.Add(new Customer("6812", "6553"));
            customers.Add(new Customer("6813", "6554"));
            customers.Add(new Customer("6814", "6555"));
            customers.Add(new Customer("6815", "6556"));
            customers.Add(new Customer("6816", "6557"));
            customers.Add(new Customer("6817", "6558"));
            customers.Add(new Customer("6818", "6559"));



            foreach (Customer customer in customers)
            {
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_09', '0', NULL, 0, 1, '2020-09-02 11:03:34', '2020-09-02 11:03:34', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_10', '0', NULL, 0, 1, '2020-09-02 11:03:35', '2020-09-02 11:03:35', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_05', '0', NULL, 0, 1, '2020-09-02 11:03:35', '2020-09-02 11:03:35', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_02', '0', NULL, 0, 1, '2020-09-02 11:03:35', '2020-09-02 11:03:35', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_12', '0', NULL, 0, 1, '2020-09-02 11:03:35', '2020-09-02 11:03:35', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_03', '0', NULL, 0, 1, '2020-09-02 11:03:35', '2020-09-02 11:03:35', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_04', '0', NULL, 0, 1, '2020-09-02 11:03:36', '2020-09-02 11:03:36', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_01', '0', NULL, 0, 1, '2020-09-02 11:03:36', '2020-09-02 11:03:36', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_08', '0', NULL, 0, 1, '2020-09-02 11:03:36', '2020-09-02 11:03:36', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_06', '0', NULL, 0, 1, '2020-09-02 11:03:36', '2020-09-02 11:03:36', NULL, NULL, " + customer.tid + ", NULL, NULL);");
                SQLmtm.ExecuteSql("INSERT INTO `fragsmart-mtm`.`a_customer_fit_r`( `CUSTOMER_ID`, `STYLE_CATEGORY_CD`, `ITEM_CD`, `ITEM_VALUE`, `FIT_VALUE`, `FIT_VALUE_CALCULATE`, `DELETE_FLAG`, `VERSION`, `CREATE_DATE`, `UPDATE_DATE`, `CREATE_USER`, `UPDATE_USER`, `FIT_COUNT_ID`, `REMARK`, `FIT_VALUE_CHANGE_LASTVALUE`) VALUES ( " + customer.cid + ", 'STYLE_CATEGORY-SHIRT', 'SHIRT_FITMT004', 'FITMT_ITEM_07', '0', NULL, 0, 1, '2020-09-02 11:03:36', '2020-09-02 11:03:36', NULL, NULL, " + customer.tid + ", NULL, NULL);");
            }
        }


        public class Customer
        {
            public Customer(string cid, string tid)
            {
                this.cid = cid;
                this.tid = tid;
            }

            public String cid { get; set; }
            public String tid { get; set; }
        }
    }
}
